CSV examples

SUMMARY

• Example of importing long and short URLs.
• Example of Importing long URLs with custom hashes.
• Example of Importing long URLs with custom short URLs
• Example of Importing long URLs with custom hashes and notes
• CVS complications

• Note that the first line is always used for column headers.
• Separate values in each line with a semicolon.
• Values enclosed in double quotes are not required, but we recommend it for URLs that contain spaces or unusual symbols.

Example 1. Import of long URLs

Short URLs will be automatically generated "url"
"https://www.yahoo.com/tech/"
"https://www.google.com/doodles"
"http://example.com/"
Download

Example 2. Import of long URLs with custom hashes

Example 3. Import of long URLs with custom short URLs

Custom hashes will be extracted from short URLs "url";"short_url"
"https://www.yahoo.com/tech/";"custom.com/37r"
"https://www.google.com/doodles";"custom.com/37s"
"http://example.com/";"custom.com/37t"
Download

Example 4. Import of long URLs with custom hashes and notes

Notes are optional "url";"short_id";"note"
"https://www.yahoo.com/tech/";"37r";""
"https://www.google.com/doodles";"37s";"Funny stuff"
"http://example.com/";"37t";"real site"
Download

In computing, comma-separated value (CSV) files store tabular data (numbers and text) in plain text. The name of this file format comes from the use of the comma as a field separator:

• Each line of the file is a data record.
• Each record consists of one or more fields, separated by commas.
• The CSV file format is not standardized. The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data contains commas or embedded line breaks. As a result:
• CSV implementations may not align with such field data.
• Alternatively, it may surround the field with quotation marks.
• Quotations, however, only solve some things.
• Unique fields may need embedded quotation marks, escape characters, or escape sequences.

• CSV format description
• URL Export and Import