Explanation

You can place orders via an XLS-files. Each column in the data file represents an attribute of a single order. Each line represents a single order. All uploaded orders are placed in the system. Publishing of the orders needs to be confirmed in the system.

You can find the correct bulk-upload file template at the bottom of this page.

Important notes

  • The first line of the XLS must contain the version number in the first column (no order!. Last version of the XLS file  is"v 1.5". Older versions are compatible but with a limited feature set

  • Briefing text in HTML format in column 12 | L must be included (Failure to upload the briefing in HTML will result in your briefing being cut short, and writers will have problems meeting your requirements.)

 

File structure

ColumnNameDescription
1 | ATitle
  • Required field
  • Title of the order
2 | BKeywords
  • Optional field
  • Separate several keyword with "|"
  • Density per keyword can be added as "(1:2)"
  • Example: Keyword 1 (1:2) | Keyword 2 (2:3)
3 | CReference-ID
  • Optional field
  • Can be used for external IDs e.g. CRM, ERP 
4 | DWord count min.
  • Required field
  • Minimum 30 words
5 | EWord count max.
  • Required field
6 | FKeyword density min.
  • Optional field
  • Applied for all keywords if not set per keyword.
7 | GKeyword density max.
  • Optional field
  • Applied for all keywords if not set per keyword
8 | HQuality level
  • Required field
  • See table below
9 | I Processing / Days 
  • Required field
  • 1- 4 days 
10 | JText type ID 
  • Required field
  • See table below
11 | KText topic ID
  • Required field
  • See table below
12 | LDetailed order description
  • Optional field 
  • Is added to the end of the briefing
  • Can be formatted as HTML
13 | MURL
  • Optional field
  • Is added to the end of the briefing
  • Can be used to link a product page, etc..

14 | NKeyword counting 
  • Required field
  • Density settings
    • 0 = relative (in % of total words)
    • 1 = absolute number
15 | OFlexendings
  • Required field
  • Flexendings settings
    • 0 = not allowed
    • 1 = allowed

16 | PStopwords
  • Required field
  • Stopwords settings
    • 0 = not allowed
    • 1 = allowed


Quality Level IDs (column 8 / H)

  • 110 = Junior Linguist  
  • 120 = Linguist    
  • 130 = Senior Linguist
  • 140 = Expert Linguist
  • 150 = Technical expert Linguist

Text type ID: (column 10 / J)

  • 1503 : Advertising text
  • 1701 : B2B text
  • 1702 : Blog
  • 1488 : Brand description
  • 1486 : Category description
  • 1562: Destination description
  • 1543 : E-books & whitepaper 
  • 1381 : Guidebooks & how-to texts
  • 1380 : Lexicon & glossary
  • 1493 : Other
  • 1484 : Promotions & offers
  • 1483 : Portraits & profiles
  • 1480 : Press release
  • 1487 : Product descriptions
  • 1492 : Rewriting
  • 1491 : Transcreation 

Text topic ID: (column 11 / K)

  • 1563 : Accomodations
  • 1580 : Adult content
  • 1526 : Apparel & accessoires
  • 1463 : Cars & trucks
  • 1522 : Cosmetics & Beauty
  • 1420 : Education & culture 
  • 1546 : Electronics & software 
  • 1600 : Energy production 
  • 1402 : Finance & insurance
  • 1301 : Fitness & sports 
  • 1322 : Food, drinks & cooking
  • 1523 : Furniture & decoration
  • 1481 : Gaming & gambling
  • 1524 : Gardening & FYI 
  • 1528 : Health & wellness
  • 1541 : Internet & programming 
  • 1441 : Law
  • 1323 : Luxury goods 
  • 1527 : Music, TV series, movies 
  • 1485 : Online & mobile marketing 
  • 1700 : Other
  • 1561 : Places of interest
  • 1461 : Pets & animals 
  • 1560 : Travelling