![]() If data points include double quotes, they need double double quotes.For example, “Chicago, IL” needs “” to tell the spreadsheet that the comma between Chicago and IL is supposed to be there and does not form part of the formatting. Use double quotes if a data point includes its own comma.For maximum compatibility, don’t add the extra space between the data point and the comma. While Excel ignores the space, some older spreadsheet programs do not. Multiple records should have a line each. You can run a line for as long as you like as long as it is a single record. You can use a pipe or tab (tab delimited) but not all spreadsheets will format it correctly. All data points must be separated by a comma to be fully compatible with most spreadsheet programs. Aside from making sure each data point is separated by a comma, what else does a fully compatible CSV file have to have? CSV is quite the flexible format but following a few logical rules can ensure your file is compatible with the widest selection of applications. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |