Using our example from before: Heading 1, Heading 1, Heading 3 It even varies from Mac to PC, Excel to Google Sheets.Īlso, you may want to check your file to see there are any empty rows after your data. Typically we find the CSV file is the issue. What you're doing in HubSpot sounds correct. if you open the CSV file in something other than Excel you need to be able to see the exact number of columns - separated by commas. If you import your data and you get errors download the error file - the instructions are helpful to find what went wrong and you can fix it. Once you've imported your data make sure you check it HubSpot. You should see the quotes around your text if there are commas in the text. Open the CSV file with Notepad (PC) or TextEdit (Mac). We're looking at the raw data using a plain text editor NOT a spreadsheet and NOT Microsoft Word.
The examples above look at the CSV file - not in Excel (or other spreadsheet). "This has 'quote marks ' in the data" will work (single quotes used instead of double quotes)."This has \"quote marks \" in the data" will work (quote marks escaped)."This has "quote marks " in the data" will fail.If your text contains quotes the you will need to "escape them" or change them to something else. The Quotes make Row 2 into 3 columns as intended. So, to solve this wrap your text in Quotes like this: Column 1, Column 2, Column 3 The importer assumes there's 4 columns of data because it's "Comma Separated" and our header only has 3 columns. and if a text cell contains any commas then the import will fail.įor example, here's a simple CSV (not Excel) file:Īpart from the incorrect use of a comma Row 2 will fail. We found the issue(s) - some spreadsheets don't automatically save the CSV (Comma Separated Values) file with quote marks around text cells.
0 kommentar(er)
