My CSV data has 100 true rows, but cells have CR LF pairs creating two lines per cell, so I'm assuming this is what's causing it to exceed the 200 row limit
I think what's happening is that the CR LFs are screwing up the CSV output, so it's a problem with my file.
Any Excel experts have any ideas on how to avoid this problem?
As long as we are talking about the cvs file anyone know how to save it and keep the top row with the column titles? This row went about halfway down the table then froze in place there.
Commas are the delimiters, but I'm guessing on import, a CR or LF or both are interpreted as the end of a row of cells. Encountering these in cells, forces the import to put everything in a single column.
Is there any way I can have two lines in a cell (without forcing a word wrap?).
A word wrap is when the text moves onto the next line when it's too big to fit on the previous line. Do you mean you want to merge two cells of text say:
Cell A:
Hello
Ceall B:
Hola
New Cell:
Hello
Hola
OR
New Cell:
Hello Hola
I'm making a table with dimensions. Each cell contains an inches value in decimal plus the equivalent fraction value to the nearest 1/16".
I can do it in Excel and format the cell in a formula, including an LF in the middle and it works fine (CR doesn't seem to be required), but when I export to a CSV file and import into a HubPages table, the LFs in cells are being interpreted as end of rows.
This is the formula - I'm concatenating everything together.
=TEXT(A3/SIN(180/$B$2*(PI()/180)),"##.00") & CHAR(10) & "(" & TEXT(MROUND(A3/SIN(180/$B$2*PI()/180),1/16), "# ?/??") & ")"
This is what it looks like in Excel
I think I'll just add a space instead of a new line, but the latter looked better.
A forced word wrap to generate a CR LF would be an option, but it's a messy way of doing it.
With the number of rows reduced to 179 and 7 columns, there still seems to be a problem importing. Everything gets put into 1 column.
I used an online CSV viewer and it worked fine, so it seems there's a bug in the CSV import code on HubPages.
As an aside, Wordpad adds a CR when it encounters an LF when viewing a file and there's no option to turn this off. Use a proper hex editor if you need to view the character codes in files.
A possible work-around the problem: Instead of inserting a table, you could do a screenshot (or 2 or 3 screenshots so that the figures are readable in the hub) and then use photo modules.
Hmm that's weird. Did you try out just one online CSV viewer? Maybe that one is special and not the norm?
Also, a table is definitely better than a picture for many reasons.
No I just tried one. It gives the option of using LF or CRLF for detecting end of row. So I tried to confuse it by adding back in an LF in one cell and it worked fine. So presumably it could tell the difference between an LF and a CRLF at the end of the line. Then I tried to confuse it further by setting LF for end of row detection so that it would think LF in a cell was the end of a row but that still worked. So I guess it had kept a record of the number of columns from previous rows and realised that the LF in a cell wasn't really a row terminator.
by Frederick S Januaries 2 years ago
Is there a way we can delete a cell in a table?
by Jack Lee 9 years ago
Is there a way to import a PDF document directly into a hub?I would like to add a PDF document into a hub's text module or photo module and can't find a good way to do it. Does anyone know how to do it or do we need to request HubPages to add this feature?It would be nice to add the PDF as is with...
by elijahirwin27 10 years ago
Could not import the clipboard because an unexpected end-of-file was encountered.This one is particularly annoying. I use Creative Suite 2, Photoshop with Windows XP Pro. I have the latest update(s).When I open Photoshop, I constantly receive the message "Could not import the...
by Kamal Ahmed 21 months ago
AS a result i can not upload information from web. please help me to normal table
by chipharris 14 years ago
Sometimes I have to import a PDF file into an Intellicad drawing. Even though I set the quality...to "HIGH", the import is almost unreadable. Is there a way to improve the quality of the imported file?Thank you,James HarrisGSCchiph@gscnc.com
by Paul Deeds 15 years ago
We just rolled out a few changes to the site. Most of the updates were minor, the big change was the addition of the table capsule. As the name suggests, it allows you to display tables of information in your hubs. You can construct them by hand or you can import data from a CSV...
Copyright © 2025 The Arena Media Brands, LLC and respective content providers on this website. HubPages® is a registered trademark of The Arena Platform, Inc. Other product and company names shown may be trademarks of their respective owners. The Arena Media Brands, LLC and respective content providers to this website may receive compensation for some links to products and services on this website.
Copyright © 2025 Maven Media Brands, LLC and respective owners.
As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.
For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://corp.maven.io/privacy-policy
Show DetailsNecessary | |
---|---|
HubPages Device ID | This is used to identify particular browsers or devices when the access the service, and is used for security reasons. |
Login | This is necessary to sign in to the HubPages Service. |
Google Recaptcha | This is used to prevent bots and spam. (Privacy Policy) |
Akismet | This is used to detect comment spam. (Privacy Policy) |
HubPages Google Analytics | This is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy) |
HubPages Traffic Pixel | This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. |
Amazon Web Services | This is a cloud services platform that we used to host our service. (Privacy Policy) |
Cloudflare | This is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy) |
Google Hosted Libraries | Javascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy) |
Features | |
---|---|
Google Custom Search | This is feature allows you to search the site. (Privacy Policy) |
Google Maps | Some articles have Google Maps embedded in them. (Privacy Policy) |
Google Charts | This is used to display charts and graphs on articles and the author center. (Privacy Policy) |
Google AdSense Host API | This service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy) |
Google YouTube | Some articles have YouTube videos embedded in them. (Privacy Policy) |
Vimeo | Some articles have Vimeo videos embedded in them. (Privacy Policy) |
Paypal | This is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy) |
Facebook Login | You can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy) |
Maven | This supports the Maven widget and search functionality. (Privacy Policy) |
Marketing | |
---|---|
Google AdSense | This is an ad network. (Privacy Policy) |
Google DoubleClick | Google provides ad serving technology and runs an ad network. (Privacy Policy) |
Index Exchange | This is an ad network. (Privacy Policy) |
Sovrn | This is an ad network. (Privacy Policy) |
Facebook Ads | This is an ad network. (Privacy Policy) |
Amazon Unified Ad Marketplace | This is an ad network. (Privacy Policy) |
AppNexus | This is an ad network. (Privacy Policy) |
Openx | This is an ad network. (Privacy Policy) |
Rubicon Project | This is an ad network. (Privacy Policy) |
TripleLift | This is an ad network. (Privacy Policy) |
Say Media | We partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy) |
Remarketing Pixels | We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites. |
Conversion Tracking Pixels | We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service. |
Statistics | |
---|---|
Author Google Analytics | This is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy) |
Comscore | ComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy) |
Amazon Tracking Pixel | Some articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy) |
Clicksco | This is a data management platform studying reader behavior (Privacy Policy) |